package cn.com.qingz.modules.user.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.github.miemiedev.mybatis.paginator.domain.PageBounds;
import com.github.miemiedev.mybatis.paginator.domain.PageList;

import cn.com.qingz.modules.user.model.DesignCase;
import cn.com.qingz.modules.user.vo.CustomerSearchCondition;
import tk.mybatis.mapper.common.Mapper;

public interface DesignCaseMapper extends Mapper<DesignCase> {

    public PageList<DesignCase> queryForPage(CustomerSearchCondition condtion, PageBounds pageBounds);

    @Select("select  * from designcase t INNER join  customer c on c.customerid = t.userid AND c.customerid =#{id}")
    public List<DesignCase> getUserDesignCase(@Param("id") Long userid);

}
